let resData = [
    { id: "01", name: "桶装方便面", pic: "u139.jpg", picHeight: 1500, picWidth: 750, price: 15.00 },
    { id: "02", name: "原味吐司", pic: "u140.jpg", picHeight: 447, picWidth: 683, price: 15.00 },
    { id: "03", name: "手撕面包", pic: "u155.jpg", picHeight: 800, picWidth: 600, price: 15.00 },
    { id: "04", name: "棒棒糖", pic: "u156.jpg", picHeight: 1024, picWidth: 676, price: 15.00 },
    { id: "05", name: "香辣鸡爪", pic: "u164.jpg", picHeight: 525, picWidth: 700, price: 15.00 },
    { id: "06", name: "虎皮鸡爪", pic: "u165.jpeg", picHeight: 516, picWidth: 743, price: 15.00 },
    { id: "07", name: "黄油曲奇", pic: "u173.jpg", picHeight: 376, picWidth: 676, price: 15.00 },
    { id: "08", name: "苏打饼", pic: "u174.jpg", picHeight: 480, picWidth: 640, price: 15.00 },
    { id: "09", name: "卫龙面筋", pic: "u182.jpg", picHeight: 1000, picWidth: 1000, price: 15.00 },
    { id: "10", name: "大面筋", pic: "u183.jpg", picHeight: 800, picWidth: 500, price: 15.00 },
  ]

let sql = `insert into MiniShopGoods (ID,Name,Categorize,PicName,PicHeight,PicWidth,CreateTime,Price,Disuse,IsPromotion ) values \n`

for (let x of resData){
    let row = [`NEWID()`,`'${x.name}'`,`'小食品'`,`'${x.pic}'`,`${x.picHeight}`,`${x.picWidth}`,`'2023-12-30'`,`${x.price}`,`0`,`0`]
    sql += ` (${row.join(',')}), \n`    
}

console.log(sql)